Dataset statistics
| Number of variables | 16 |
|---|---|
| Number of observations | 2628 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 236.2 KiB |
| Average record size in memory | 92.0 B |
Variable types
| Numeric | 12 |
|---|---|
| Categorical | 3 |
| DateTime | 1 |
monto_credito is highly correlated with saldo_capital and 3 other fields | High correlation |
saldo_capital is highly correlated with monto_credito and 3 other fields | High correlation |
saldo_Ahorro is highly correlated with monto_credito and 2 other fields | High correlation |
Antiguedad_en_meses is highly correlated with monto_credito and 2 other fields | High correlation |
plazo_dias is highly correlated with monto_credito and 1 other fields | High correlation |
monto_credito is highly correlated with saldo_capital and 2 other fields | High correlation |
saldo_capital is highly correlated with monto_credito and 2 other fields | High correlation |
saldo_Ahorro is highly correlated with monto_credito and 2 other fields | High correlation |
Antiguedad_en_meses is highly correlated with saldo_Ahorro | High correlation |
plazo_dias is highly correlated with monto_credito and 1 other fields | High correlation |
Patrimonio is highly correlated with tasa and 1 other fields | High correlation |
Ingresos_Mensuales is highly correlated with tasa and 1 other fields | High correlation |
No_hijos is highly correlated with tasa and 1 other fields | High correlation |
monto_credito is highly correlated with tasa and 2 other fields | High correlation |
tasa is highly correlated with Patrimonio and 4 other fields | High correlation |
saldo_capital is highly correlated with monto_credito and 2 other fields | High correlation |
saldo_Ahorro is highly correlated with saldo_capital and 1 other fields | High correlation |
Antiguedad_en_meses is highly correlated with Max_dias_mora | High correlation |
Max_dias_mora is highly correlated with Patrimonio and 7 other fields | High correlation |
Id_Cliente is highly correlated with Ciudad and 1 other fields | High correlation |
Ciudad is highly correlated with Id_Cliente and 1 other fields | High correlation |
Patrimonio is highly correlated with Id_Cliente and 1 other fields | High correlation |
fecha_ult_desembolso is highly correlated with Ciudad and 9 other fields | High correlation |
monto_credito is highly correlated with fecha_ult_desembolso and 4 other fields | High correlation |
tasa is highly correlated with fecha_ult_desembolso and 1 other fields | High correlation |
saldo_capital is highly correlated with fecha_ult_desembolso and 4 other fields | High correlation |
saldo_Ahorro is highly correlated with fecha_ult_desembolso and 5 other fields | High correlation |
Antiguedad_en_meses is highly correlated with fecha_ult_desembolso and 3 other fields | High correlation |
Max_dias_mora is highly correlated with fecha_ult_desembolso | High correlation |
plazo_dias is highly correlated with fecha_ult_desembolso and 3 other fields | High correlation |
Edad is highly correlated with fecha_ult_desembolso | High correlation |
Ingresos_Mensuales is highly skewed (γ1 = 24.53368732) | Skewed |
Id_Cliente is uniformly distributed | Uniform |
Id_Cliente has unique values | Unique |
saldo_Ahorro has 109 (4.1%) zeros | Zeros |
Max_dias_mora has 2224 (84.6%) zeros | Zeros |
Reproduction
| Analysis started | 2022-04-03 18:31:38.266292 |
|---|---|
| Analysis finished | 2022-04-03 18:34:38.349179 |
| Duration | 3 minutes and 0.08 seconds |
| Software version | pandas-profiling v3.1.0 |
| Download configuration | config.json |
| Distinct | 2628 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 218268.5 |
| Minimum | 216955 |
|---|---|
| Maximum | 219582 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 20.7 KiB |
Quantile statistics
| Minimum | 216955 |
|---|---|
| 5-th percentile | 217086.35 |
| Q1 | 217611.75 |
| median | 218268.5 |
| Q3 | 218925.25 |
| 95-th percentile | 219450.65 |
| Maximum | 219582 |
| Range | 2627 |
| Interquartile range (IQR) | 1313.5 |
Descriptive statistics
| Standard deviation | 758.7825776 |
|---|---|
| Coefficient of variation (CV) | 0.003476372347 |
| Kurtosis | -1.2 |
| Mean | 218268.5 |
| Median Absolute Deviation (MAD) | 657 |
| Skewness | 0 |
| Sum | 573609618 |
| Variance | 575751 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 216966 | 1 | < 0.1% |
| 217451 | 1 | < 0.1% |
| 219558 | 1 | < 0.1% |
| 218213 | 1 | < 0.1% |
| 218465 | 1 | < 0.1% |
| 218717 | 1 | < 0.1% |
| 219016 | 1 | < 0.1% |
| 219183 | 1 | < 0.1% |
| 219320 | 1 | < 0.1% |
| 219443 | 1 | < 0.1% |
| Other values (2618) | 2618 |
| Value | Count | Frequency (%) |
| 216955 | 1 | |
| 216956 | 1 | |
| 216957 | 1 | |
| 216958 | 1 | |
| 216959 | 1 | |
| 216960 | 1 | |
| 216961 | 1 | |
| 216962 | 1 | |
| 216963 | 1 | |
| 216964 | 1 |
| Value | Count | Frequency (%) |
| 219582 | 1 | |
| 219581 | 1 | |
| 219580 | 1 | |
| 219579 | 1 | |
| 219578 | 1 | |
| 219577 | 1 | |
| 219576 | 1 | |
| 219575 | 1 | |
| 219574 | 1 | |
| 219573 | 1 |
| Distinct | 4 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 20.7 KiB |
| Cali | |
|---|---|
| Bogotá | |
| Cartagena | |
| Barranquilla |
Length
| Max length | 12 |
|---|---|
| Median length | 6 |
| Mean length | 7.489726027 |
| Min length | 4 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Barranquilla |
|---|---|
| 2nd row | Barranquilla |
| 3rd row | Barranquilla |
| 4th row | Barranquilla |
| 5th row | Barranquilla |
Common Values
| Value | Count | Frequency (%) |
| Cali | 756 | |
| Bogotá | 654 | |
| Cartagena | 627 | |
| Barranquilla | 591 |
Length
Pie chart
| Value | Count | Frequency (%) |
| cali | 756 | |
| bogotá | 654 | |
| cartagena | 627 | |
| barranquilla | 591 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 1079 |
|---|---|
| Distinct (%) | 41.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 48824658.48 |
| Minimum | 96817 |
|---|---|
| Maximum | 99901000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 10.4 KiB |
Quantile statistics
| Minimum | 96817 |
|---|---|
| 5-th percentile | 6778897.05 |
| Q1 | 24284500 |
| median | 48767000 |
| Q3 | 72493000 |
| 95-th percentile | 93690900 |
| Maximum | 99901000 |
| Range | 99804183 |
| Interquartile range (IQR) | 48208500 |
Descriptive statistics
| Standard deviation | 28098004.76 |
|---|---|
| Coefficient of variation (CV) | 0.5754879938 |
| Kurtosis | -1.155972711 |
| Mean | 48824658.48 |
| Median Absolute Deviation (MAD) | 24256500 |
| Skewness | 0.06271137545 |
| Sum | 1.283112025 × 1011 |
| Variance | 7.894978714 × 1014 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 42078698 | 20 | 0.8% |
| 84578000 | 20 | 0.8% |
| 50000000 | 18 | 0.7% |
| 19380000 | 15 | 0.6% |
| 18392000 | 11 | 0.4% |
| 77506000 | 7 | 0.3% |
| 83900000 | 6 | 0.2% |
| 54515000 | 6 | 0.2% |
| 59174000 | 4 | 0.2% |
| 10715000 | 4 | 0.2% |
| Other values (1069) | 2517 |
| Value | Count | Frequency (%) |
| 96817 | 1 | |
| 191077 | 1 | |
| 236802 | 1 | |
| 327170 | 1 | |
| 335448 | 1 | |
| 495559 | 1 | |
| 607578 | 1 | |
| 652714 | 1 | |
| 778071 | 1 | |
| 879060 | 1 |
| Value | Count | Frequency (%) |
| 99901000 | 3 | |
| 99890340 | 1 | < 0.1% |
| 99833000 | 3 | |
| 99830010 | 2 | |
| 99615000 | 3 | |
| 99609000 | 3 | |
| 99399000 | 3 | |
| 99376000 | 3 | |
| 99360000 | 4 | |
| 99116000 | 3 |
| Distinct | 884 |
|---|---|
| Distinct (%) | 33.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1499859.435 |
| Minimum | 421263 |
|---|---|
| Maximum | 28336624 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 10.4 KiB |
Quantile statistics
| Minimum | 421263 |
|---|---|
| 5-th percentile | 774589 |
| Q1 | 1185693 |
| median | 1493587 |
| Q3 | 1768731 |
| 95-th percentile | 2166280 |
| Maximum | 28336624 |
| Range | 27915361 |
| Interquartile range (IQR) | 583038 |
Descriptive statistics
| Standard deviation | 669294.061 |
|---|---|
| Coefficient of variation (CV) | 0.4462378576 |
| Kurtosis | 983.5742844 |
| Mean | 1499859.435 |
| Median Absolute Deviation (MAD) | 298457 |
| Skewness | 24.53368732 |
| Sum | 3941630595 |
| Variance | 4.479545401 × 1011 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 861085 | 78 | 3.0% |
| 774587 | 40 | 1.5% |
| 747054 | 38 | 1.4% |
| 774589 | 30 | 1.1% |
| 774851 | 18 | 0.7% |
| 1689669 | 4 | 0.2% |
| 1586433 | 4 | 0.2% |
| 1744197 | 4 | 0.2% |
| 960591 | 4 | 0.2% |
| 1628879 | 4 | 0.2% |
| Other values (874) | 2404 |
| Value | Count | Frequency (%) |
| 421263 | 1 | < 0.1% |
| 437465 | 1 | < 0.1% |
| 483633 | 1 | < 0.1% |
| 521160 | 1 | < 0.1% |
| 563316 | 1 | < 0.1% |
| 667402 | 3 | |
| 671241 | 3 | |
| 677193 | 3 | |
| 686453 | 3 | |
| 688114 | 3 |
| Value | Count | Frequency (%) |
| 28336624 | 1 | < 0.1% |
| 2336623 | 1 | < 0.1% |
| 2336622 | 1 | < 0.1% |
| 2326144 | 2 | |
| 2324651 | 1 | < 0.1% |
| 2319325 | 2 | |
| 2312279 | 1 | < 0.1% |
| 2310578 | 2 | |
| 2308736 | 3 | |
| 2308470 | 3 |
| Distinct | 5 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 20.7 KiB |
| 0 | |
|---|---|
| 2 | |
| 1 | |
| 3 | 7 |
| 4 | 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 2 |
| 3rd row | 0 |
| 4th row | 2 |
| 5th row | 2 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 932 | |
| 2 | 872 | |
| 1 | 816 | |
| 3 | 7 | 0.3% |
| 4 | 1 | < 0.1% |
Length
Pie chart
| Value | Count | Frequency (%) |
| 0 | 932 | |
| 2 | 872 | |
| 1 | 816 | |
| 3 | 7 | 0.3% |
| 4 | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
oficina
Real number (ℝ≥0)
| Distinct | 29 |
|---|---|
| Distinct (%) | 1.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5461.408295 |
| Minimum | 4003 |
|---|---|
| Maximum | 7064 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 20.7 KiB |
Quantile statistics
| Minimum | 4003 |
|---|---|
| 5-th percentile | 4005 |
| Q1 | 4017 |
| median | 4054 |
| Q3 | 7030 |
| 95-th percentile | 7064 |
| Maximum | 7064 |
| Range | 3061 |
| Interquartile range (IQR) | 3013 |
Descriptive statistics
| Standard deviation | 1504.387868 |
|---|---|
| Coefficient of variation (CV) | 0.2754578648 |
| Kurtosis | -1.993230415 |
| Mean | 5461.408295 |
| Median Absolute Deviation (MAD) | 51 |
| Skewness | 0.08843011358 |
| Sum | 14352581 |
| Variance | 2263182.858 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 4010 | 325 | |
| 7025 | 285 | 10.8% |
| 7032 | 275 | 10.5% |
| 4024 | 218 | 8.3% |
| 7064 | 197 | 7.5% |
| 4011 | 155 | 5.9% |
| 4050 | 137 | 5.2% |
| 4005 | 103 | 3.9% |
| 7030 | 101 | 3.8% |
| 4031 | 93 | 3.5% |
| Other values (19) | 739 |
| Value | Count | Frequency (%) |
| 4003 | 64 | 2.4% |
| 4005 | 103 | 3.9% |
| 4010 | 325 | |
| 4011 | 155 | |
| 4014 | 3 | 0.1% |
| 4017 | 17 | 0.6% |
| 4024 | 218 | |
| 4025 | 57 | 2.2% |
| 4030 | 82 | 3.1% |
| 4031 | 93 | 3.5% |
| Value | Count | Frequency (%) |
| 7064 | 197 | |
| 7059 | 30 | 1.1% |
| 7051 | 20 | 0.8% |
| 7046 | 19 | 0.7% |
| 7044 | 3 | 0.1% |
| 7041 | 21 | 0.8% |
| 7039 | 19 | 0.7% |
| 7038 | 55 | 2.1% |
| 7032 | 275 | |
| 7030 | 101 | 3.8% |
| Distinct | 100 |
|---|---|
| Distinct (%) | 3.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 20.7 KiB |
| Minimum | 2017-01-04 00:00:00 |
|---|---|
| Maximum | 2017-12-06 00:00:00 |
| Distinct | 233 |
|---|---|
| Distinct (%) | 8.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2211341.394 |
| Minimum | 300000 |
|---|---|
| Maximum | 9800000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 10.4 KiB |
Quantile statistics
| Minimum | 300000 |
|---|---|
| 5-th percentile | 500000 |
| Q1 | 1031210 |
| median | 2000000 |
| Q3 | 2896255 |
| 95-th percentile | 5534420 |
| Maximum | 9800000 |
| Range | 9500000 |
| Interquartile range (IQR) | 1865045 |
Descriptive statistics
| Standard deviation | 1666275.124 |
|---|---|
| Coefficient of variation (CV) | 0.7535132877 |
| Kurtosis | 3.849787996 |
| Mean | 2211341.394 |
| Median Absolute Deviation (MAD) | 961115 |
| Skewness | 1.784314133 |
| Sum | 5811405183 |
| Variance | 2.776472788 × 1012 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2000000 | 289 | 11.0% |
| 1500000 | 162 | 6.2% |
| 1000000 | 156 | 5.9% |
| 3000000 | 126 | 4.8% |
| 5000000 | 91 | 3.5% |
| 800000 | 87 | 3.3% |
| 4000000 | 84 | 3.2% |
| 500000 | 73 | 2.8% |
| 2500000 | 64 | 2.4% |
| 1200000 | 53 | 2.0% |
| Other values (223) | 1443 |
| Value | Count | Frequency (%) |
| 300000 | 18 | |
| 320000 | 10 | 0.4% |
| 330000 | 3 | 0.1% |
| 346560 | 3 | 0.1% |
| 350000 | 6 | 0.2% |
| 370000 | 3 | 0.1% |
| 400000 | 25 | |
| 438800 | 6 | 0.2% |
| 444000 | 3 | 0.1% |
| 446560 | 3 | 0.1% |
| Value | Count | Frequency (%) |
| 9800000 | 1 | < 0.1% |
| 9500000 | 14 | |
| 9458720 | 3 | 0.1% |
| 9000000 | 13 | |
| 8900000 | 5 | 0.2% |
| 8000000 | 7 | |
| 7307700 | 3 | 0.1% |
| 7279360 | 4 | 0.2% |
| 7000000 | 3 | 0.1% |
| 6900000 | 9 |
| Distinct | 16 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 28.66285388 |
| Minimum | 0.21 |
|---|---|
| Maximum | 33.93 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 20.7 KiB |
Quantile statistics
| Minimum | 0.21 |
|---|---|
| 5-th percentile | 0.3 |
| Q1 | 33.93 |
| median | 33.93 |
| Q3 | 33.93 |
| 95-th percentile | 33.93 |
| Maximum | 33.93 |
| Range | 33.72 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 12.01441028 |
|---|---|
| Coefficient of variation (CV) | 0.4191630857 |
| Kurtosis | 1.734011528 |
| Mean | 28.66285388 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -1.922999514 |
| Sum | 75325.98 |
| Variance | 144.3460544 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 33.93 | 2065 | |
| 0.3 | 367 | 14.0% |
| 33.18 | 88 | 3.3% |
| 28.73 | 33 | 1.3% |
| 28.07 | 15 | 0.6% |
| 0.28 | 12 | 0.5% |
| 0.21 | 12 | 0.5% |
| 31.89 | 6 | 0.2% |
| 32.09 | 6 | 0.2% |
| 21.94 | 6 | 0.2% |
| Other values (6) | 18 | 0.7% |
| Value | Count | Frequency (%) |
| 0.21 | 12 | 0.5% |
| 0.23 | 3 | 0.1% |
| 0.25 | 3 | 0.1% |
| 0.28 | 12 | 0.5% |
| 0.3 | 367 | |
| 21.94 | 6 | 0.2% |
| 22.6 | 3 | 0.1% |
| 25.12 | 3 | 0.1% |
| 28.07 | 15 | 0.6% |
| 28.73 | 33 | 1.3% |
| Value | Count | Frequency (%) |
| 33.93 | 2065 | |
| 33.18 | 88 | 3.3% |
| 32.88 | 3 | 0.1% |
| 32.27 | 3 | 0.1% |
| 32.09 | 6 | 0.2% |
| 31.89 | 6 | 0.2% |
| 28.73 | 33 | 1.3% |
| 28.07 | 15 | 0.6% |
| 25.12 | 3 | 0.1% |
| 22.6 | 3 | 0.1% |
| Distinct | 731 |
|---|---|
| Distinct (%) | 27.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1621322.632 |
| Minimum | 18714 |
|---|---|
| Maximum | 9925519 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 10.4 KiB |
Quantile statistics
| Minimum | 18714 |
|---|---|
| 5-th percentile | 239561 |
| Q1 | 649156 |
| median | 1105952.5 |
| Q3 | 2093885.25 |
| 95-th percentile | 4764789 |
| Maximum | 9925519 |
| Range | 9906805 |
| Interquartile range (IQR) | 1444729.25 |
Descriptive statistics
| Standard deviation | 1452214.048 |
|---|---|
| Coefficient of variation (CV) | 0.8956971416 |
| Kurtosis | 5.603847279 |
| Mean | 1621322.632 |
| Median Absolute Deviation (MAD) | 639768.5 |
| Skewness | 2.060017777 |
| Sum | 4260835878 |
| Variance | 2.10892564 × 1012 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1000000 | 34 | 1.3% |
| 800000 | 29 | 1.1% |
| 2000000 | 28 | 1.1% |
| 1500000 | 27 | 1.0% |
| 2093120 | 26 | 1.0% |
| 1046560 | 25 | 1.0% |
| 2500000 | 25 | 1.0% |
| 662393 | 16 | 0.6% |
| 500000 | 15 | 0.6% |
| 2069840 | 15 | 0.6% |
| Other values (721) | 2388 |
| Value | Count | Frequency (%) |
| 18714 | 3 | |
| 40642 | 4 | |
| 75942 | 3 | |
| 79398 | 3 | |
| 94241 | 3 | |
| 94933 | 3 | |
| 95896 | 3 | |
| 96841 | 3 | |
| 99290 | 3 | |
| 100600 | 3 |
| Value | Count | Frequency (%) |
| 9925519 | 3 | |
| 9647385 | 3 | |
| 9000000 | 2 | |
| 8840686 | 3 | |
| 8443599 | 3 | |
| 8253065 | 3 | |
| 7810084 | 3 | |
| 7800000 | 1 | < 0.1% |
| 7224190 | 3 | |
| 6915555 | 3 |
saldo_Ahorro
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 784 |
|---|---|
| Distinct (%) | 29.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 28469.95396 |
| Minimum | 0 |
|---|---|
| Maximum | 159843 |
| Zeros | 109 |
| Zeros (%) | 4.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 20.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1358 |
| Q1 | 9474 |
| median | 20631 |
| Q3 | 39369 |
| 95-th percentile | 83782 |
| Maximum | 159843 |
| Range | 159843 |
| Interquartile range (IQR) | 29895 |
Descriptive statistics
| Standard deviation | 26320.43199 |
|---|---|
| Coefficient of variation (CV) | 0.9244985793 |
| Kurtosis | 3.748261407 |
| Mean | 28469.95396 |
| Median Absolute Deviation (MAD) | 12431.5 |
| Skewness | 1.743781837 |
| Sum | 74819039 |
| Variance | 692765140 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 109 | 4.1% |
| 63658 | 13 | 0.5% |
| 20370 | 10 | 0.4% |
| 20631 | 10 | 0.4% |
| 19713 | 9 | 0.3% |
| 38195 | 9 | 0.3% |
| 24642 | 9 | 0.3% |
| 53297 | 8 | 0.3% |
| 53890 | 7 | 0.3% |
| 18262 | 7 | 0.3% |
| Other values (774) | 2437 |
| Value | Count | Frequency (%) |
| 0 | 109 | |
| 571 | 3 | 0.1% |
| 662 | 3 | 0.1% |
| 884 | 3 | 0.1% |
| 921 | 3 | 0.1% |
| 1066 | 1 | < 0.1% |
| 1086 | 3 | 0.1% |
| 1114 | 3 | 0.1% |
| 1178 | 3 | 0.1% |
| 1358 | 3 | 0.1% |
| Value | Count | Frequency (%) |
| 159843 | 3 | |
| 158582 | 3 | |
| 152113 | 3 | |
| 145541 | 2 | |
| 137405 | 3 | |
| 137084 | 2 | |
| 136479 | 3 | |
| 136343 | 3 | |
| 132549 | 3 | |
| 123216 | 3 |
Antiguedad_en_meses
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATION| Distinct | 110 |
|---|---|
| Distinct (%) | 4.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 76.20890411 |
| Minimum | 11 |
|---|---|
| Maximum | 120 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 10.4 KiB |
Quantile statistics
| Minimum | 11 |
|---|---|
| 5-th percentile | 12 |
| Q1 | 43 |
| median | 82 |
| Q3 | 117 |
| 95-th percentile | 118 |
| Maximum | 120 |
| Range | 109 |
| Interquartile range (IQR) | 74 |
Descriptive statistics
| Standard deviation | 36.80815971 |
|---|---|
| Coefficient of variation (CV) | 0.482990277 |
| Kurtosis | -1.234072337 |
| Mean | 76.20890411 |
| Median Absolute Deviation (MAD) | 35 |
| Skewness | -0.3823715749 |
| Sum | 200277 |
| Variance | 1354.840621 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 117 | 561 | 21.3% |
| 12 | 201 | 7.6% |
| 118 | 99 | 3.8% |
| 82 | 81 | 3.1% |
| 95 | 59 | 2.2% |
| 77 | 48 | 1.8% |
| 34 | 45 | 1.7% |
| 62 | 44 | 1.7% |
| 94 | 43 | 1.6% |
| 78 | 42 | 1.6% |
| Other values (100) | 1405 |
| Value | Count | Frequency (%) |
| 11 | 12 | 0.5% |
| 12 | 201 | |
| 13 | 21 | 0.8% |
| 14 | 9 | 0.3% |
| 15 | 3 | 0.1% |
| 16 | 6 | 0.2% |
| 17 | 22 | 0.8% |
| 18 | 4 | 0.2% |
| 19 | 3 | 0.1% |
| 20 | 13 | 0.5% |
| Value | Count | Frequency (%) |
| 120 | 14 | 0.5% |
| 119 | 26 | 1.0% |
| 118 | 99 | 3.8% |
| 117 | 561 | |
| 116 | 41 | 1.6% |
| 115 | 6 | 0.2% |
| 114 | 3 | 0.1% |
| 113 | 34 | 1.3% |
| 112 | 8 | 0.3% |
| 111 | 9 | 0.3% |
| Distinct | 49 |
|---|---|
| Distinct (%) | 1.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.732115677 |
| Minimum | 0 |
|---|---|
| Maximum | 96 |
| Zeros | 2224 |
| Zeros (%) | 84.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 10.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 27 |
| Maximum | 96 |
| Range | 96 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 14.97872377 |
|---|---|
| Coefficient of variation (CV) | 3.165333392 |
| Kurtosis | 17.39820812 |
| Mean | 4.732115677 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 4.062429051 |
| Sum | 12436 |
| Variance | 224.3621658 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 2224 | |
| 26 | 38 | 1.4% |
| 12 | 38 | 1.4% |
| 11 | 27 | 1.0% |
| 4 | 27 | 1.0% |
| 90 | 25 | 1.0% |
| 20 | 23 | 0.9% |
| 8 | 15 | 0.6% |
| 15 | 15 | 0.6% |
| 25 | 15 | 0.6% |
| Other values (39) | 181 | 6.9% |
| Value | Count | Frequency (%) |
| 0 | 2224 | |
| 4 | 27 | 1.0% |
| 6 | 9 | 0.3% |
| 7 | 3 | 0.1% |
| 8 | 15 | 0.6% |
| 9 | 3 | 0.1% |
| 10 | 9 | 0.3% |
| 11 | 27 | 1.0% |
| 12 | 38 | 1.4% |
| 15 | 15 | 0.6% |
| Value | Count | Frequency (%) |
| 96 | 1 | < 0.1% |
| 93 | 1 | < 0.1% |
| 92 | 1 | < 0.1% |
| 90 | 25 | |
| 89 | 4 | 0.2% |
| 88 | 4 | 0.2% |
| 83 | 3 | 0.1% |
| 80 | 2 | 0.1% |
| 78 | 3 | 0.1% |
| 73 | 4 | 0.2% |
| Distinct | 27 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 653.2191781 |
| Minimum | 144 |
|---|---|
| Maximum | 1080 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 10.4 KiB |
Quantile statistics
| Minimum | 144 |
|---|---|
| 5-th percentile | 360 |
| Q1 | 450 |
| median | 600 |
| Q3 | 720 |
| 95-th percentile | 1080 |
| Maximum | 1080 |
| Range | 936 |
| Interquartile range (IQR) | 270 |
Descriptive statistics
| Standard deviation | 259.9916002 |
|---|---|
| Coefficient of variation (CV) | 0.3980158712 |
| Kurtosis | -0.9399454714 |
| Mean | 653.2191781 |
| Median Absolute Deviation (MAD) | 150 |
| Skewness | 0.3790515569 |
| Sum | 1716660 |
| Variance | 67595.63219 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 720 | 659 | |
| 1080 | 492 | |
| 540 | 465 | |
| 360 | 456 | |
| 450 | 209 | 8.0% |
| 900 | 110 | 4.2% |
| 300 | 62 | 2.4% |
| 600 | 39 | 1.5% |
| 180 | 29 | 1.1% |
| 240 | 15 | 0.6% |
| Other values (17) | 92 | 3.5% |
| Value | Count | Frequency (%) |
| 144 | 10 | 0.4% |
| 180 | 29 | 1.1% |
| 210 | 6 | 0.2% |
| 240 | 15 | 0.6% |
| 270 | 6 | 0.2% |
| 300 | 62 | 2.4% |
| 330 | 3 | 0.1% |
| 360 | 456 | |
| 420 | 7 | 0.3% |
| 450 | 209 |
| Value | Count | Frequency (%) |
| 1080 | 492 | |
| 1050 | 3 | 0.1% |
| 1020 | 3 | 0.1% |
| 990 | 3 | 0.1% |
| 960 | 4 | 0.2% |
| 900 | 110 | 4.2% |
| 840 | 6 | 0.2% |
| 780 | 4 | 0.2% |
| 750 | 3 | 0.1% |
| 720 | 659 |
| Distinct | 50 |
|---|---|
| Distinct (%) | 1.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 43.79642314 |
| Minimum | 20 |
|---|---|
| Maximum | 69 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 10.4 KiB |
Quantile statistics
| Minimum | 20 |
|---|---|
| 5-th percentile | 22 |
| Q1 | 31 |
| median | 43 |
| Q3 | 56 |
| 95-th percentile | 67 |
| Maximum | 69 |
| Range | 49 |
| Interquartile range (IQR) | 25 |
Descriptive statistics
| Standard deviation | 14.21034122 |
|---|---|
| Coefficient of variation (CV) | 0.324463511 |
| Kurtosis | -1.184097966 |
| Mean | 43.79642314 |
| Median Absolute Deviation (MAD) | 12 |
| Skewness | 0.1050417052 |
| Sum | 115097 |
| Variance | 201.9337976 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 40 | 112 | 4.3% |
| 28 | 105 | 4.0% |
| 27 | 81 | 3.1% |
| 53 | 79 | 3.0% |
| 38 | 75 | 2.9% |
| 35 | 71 | 2.7% |
| 22 | 69 | 2.6% |
| 31 | 67 | 2.5% |
| 62 | 62 | 2.4% |
| 46 | 61 | 2.3% |
| Other values (40) | 1846 |
| Value | Count | Frequency (%) |
| 20 | 38 | 1.4% |
| 21 | 51 | |
| 22 | 69 | |
| 23 | 31 | 1.2% |
| 24 | 34 | 1.3% |
| 25 | 55 | |
| 26 | 52 | |
| 27 | 81 | |
| 28 | 105 | |
| 29 | 32 | 1.2% |
| Value | Count | Frequency (%) |
| 69 | 35 | |
| 68 | 58 | |
| 67 | 57 | |
| 66 | 45 | |
| 65 | 42 | |
| 64 | 55 | |
| 63 | 53 | |
| 62 | 62 | |
| 61 | 42 | |
| 60 | 35 |
Acepta_Campaña
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 20.7 KiB |
| 0 | |
|---|---|
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 1322 | |
| 1 | 1306 |
Length
Pie chart
| Value | Count | Frequency (%) |
| 0 | 1322 | |
| 1 | 1306 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| Id_Cliente | Ciudad | Patrimonio | Ingresos_Mensuales | No_hijos | oficina | fecha_ult_desembolso | monto_credito | tasa | saldo_capital | saldo_Ahorro | Antiguedad_en_meses | Max_dias_mora | plazo_dias | Edad | Acepta_Campaña | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 216966 | Barranquilla | 13224000 | 2042480 | 1 | 4024 | 2017-05-14 | 1500000 | 33.93 | 1357387 | 33438 | 12 | 0 | 900 | 50 | 1 |
| 1 | 216967 | Barranquilla | 13380000 | 1513835 | 2 | 4011 | 2017-02-05 | 1500000 | 33.93 | 392262 | 0 | 12 | 0 | 540 | 59 | 1 |
| 2 | 216978 | Barranquilla | 17320000 | 1594497 | 0 | 7032 | 2017-02-07 | 1064170 | 0.30 | 211724 | 0 | 12 | 0 | 540 | 63 | 1 |
| 3 | 216979 | Barranquilla | 17439000 | 1104406 | 2 | 7032 | 2017-09-05 | 2338552 | 0.30 | 828993 | 0 | 12 | 0 | 720 | 55 | 1 |
| 4 | 217028 | Barranquilla | 41366000 | 1988538 | 2 | 7025 | 2017-07-06 | 2385560 | 33.93 | 1997956 | 0 | 12 | 0 | 720 | 45 | 0 |
| 5 | 217029 | Barranquilla | 41771000 | 1690652 | 1 | 7032 | 2017-11-06 | 4000000 | 0.30 | 1538055 | 8844 | 12 | 0 | 720 | 55 | 1 |
| 6 | 217044 | Barranquilla | 49007000 | 868070 | 0 | 7025 | 2017-04-20 | 2300000 | 33.93 | 2081267 | 0 | 12 | 0 | 720 | 37 | 1 |
| 7 | 217067 | Barranquilla | 57815000 | 1338413 | 2 | 4005 | 2017-09-06 | 1200000 | 33.18 | 363970 | 0 | 12 | 0 | 450 | 38 | 1 |
| 8 | 217074 | Barranquilla | 61457000 | 2024862 | 2 | 4014 | 2017-05-14 | 2000000 | 25.12 | 1005056 | 132549 | 12 | 0 | 900 | 69 | 1 |
| 9 | 217077 | Barranquilla | 63614000 | 1135835 | 0 | 7025 | 2017-06-25 | 1500000 | 33.93 | 1329227 | 13104 | 12 | 0 | 450 | 69 | 1 |
Last rows
| Id_Cliente | Ciudad | Patrimonio | Ingresos_Mensuales | No_hijos | oficina | fecha_ult_desembolso | monto_credito | tasa | saldo_capital | saldo_Ahorro | Antiguedad_en_meses | Max_dias_mora | plazo_dias | Edad | Acepta_Campaña | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2618 | 219271 | Cartagena | 20080000 | 1555351 | 1 | 4005 | 2017-04-07 | 800000 | 28.07 | 680293 | 29154 | 119 | 90 | 360 | 61 | 1 |
| 2619 | 217677 | Bogotá | 62408000 | 1613334 | 0 | 7019 | 2017-08-05 | 4000000 | 0.21 | 1972176 | 41874 | 119 | 7 | 1080 | 34 | 0 |
| 2620 | 217895 | Bogotá | 62408000 | 747054 | 2 | 7019 | 2017-08-05 | 4000000 | 0.21 | 1972176 | 41874 | 119 | 7 | 1080 | 34 | 1 |
| 2621 | 218113 | Bogotá | 62408000 | 1613334 | 2 | 7019 | 2017-08-05 | 4000000 | 0.21 | 1972176 | 41874 | 119 | 7 | 1080 | 34 | 1 |
| 2622 | 217716 | Bogotá | 81537000 | 2149601 | 0 | 4003 | 2017-04-13 | 9000000 | 33.93 | 7810084 | 18603 | 119 | 0 | 1080 | 53 | 0 |
| 2623 | 217934 | Bogotá | 81537000 | 747054 | 0 | 4003 | 2017-04-13 | 9000000 | 33.93 | 7810084 | 18603 | 120 | 0 | 1080 | 53 | 1 |
| 2624 | 218152 | Bogotá | 81537000 | 2149601 | 0 | 4003 | 2017-04-13 | 8900000 | 33.93 | 7810084 | 18603 | 120 | 0 | 1080 | 53 | 1 |
| 2625 | 217713 | Bogotá | 84578000 | 1952025 | 2 | 4030 | 2017-04-29 | 9000000 | 33.93 | 9000000 | 19713 | 120 | 0 | 720 | 52 | 0 |
| 2626 | 217931 | Bogotá | 79817000 | 747054 | 2 | 4030 | 2017-04-29 | 9000000 | 33.93 | 9000000 | 19713 | 120 | 0 | 720 | 52 | 1 |
| 2627 | 218149 | Bogotá | 79817000 | 1952025 | 2 | 4030 | 2017-04-29 | 8900000 | 33.93 | 7800000 | 19713 | 120 | 0 | 720 | 52 | 1 |